SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
and(InteriorFeat like '%Fireplace%') and(InteriorFeat like '%Fireplace%')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 20
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:HERMIT HILL FARM- One of the most rare and spectacular estates in the region, the property sits on 700 pristine acres minutes from Lyme Village and a very short trip to Hanover, home of Dartmouth College. The farm has been in the same family for generations. The area around the main house is idyllic, with rolling fields, a large swimming pond with beach, apple orchard, gorgeous landscaped grounds, quaint barns, and western views from several areas. The farm operated as an equestrian estate for many years and has a 11-stall central barn with solar array, large indoor riding arena, outdoor arena, and fenced paddocks with run-in sheds. There are miles of trails to explore the property, perfect for hikes, walks with the dogs, snowshoeing or x-country skiing, ATV riding, and mountain biking. The main hill on the south side of the house even once had its own ski-tow, later replaced by snowmobiles. The main house is spacious and sophisticated and has been expanded over the years to include a private bedroom wing and large great room for family gatherings. There are 5 bedrooms and 5 baths in total. The historic details of the interiors are beautiful– warm woodwork and original paneling with modern sophistication such as radiant flooring and top of the line appliances. The farm is in conservation but allows for potential subdivision and there is significant timber value. This farm is a true New England gem and needs to be experienced. Note: some interior photos were virtually staged.
Description:Steeped in the tradition and history of Dartmouth College, The Carleton House at 4 Occom Ridge is a landmark home in what is arguably Hanover's finest residential neighborhood. Sited on the crest of Occom Ridge and offering 273’ of frontage and westerly views over the Connecticut River, the 1.2-acre property is accessed by private driveway and is a short walk to Pine Park, the Dartmouth College campus and downtown Hanover. The main house, an historic ca. 1897 seven-bedroom shingle style wood framed home, is attached to a distinct four-bedroom accessory dwelling making this a very unique property. Well-maintained with improvements by the current owners, historic charm is preserved through many original features; graciously proportioned, light-filled common rooms, architectural details such as raised paneling, chair rails, wainscot, crown moldings and warmth of hardwood flooring fill the interior with a strong sense of history. The second house, connected by both an exterior walkway and enclosed breezeway, offers an open living/dining room, kitchen, first floor bedroom, two bathrooms and three additional bedrooms upstairs. Gracious, spacious, and confident in its place in the history of Hanover and Dartmouth, the Carleton House is a rare opportunity to own a Hanover gem.